How To Prevent SAVE In Word
Jan 29, 2009how to prevent a user saving a Word Document.
View 9 Replies
ADVERTISEMENT
Prevent Word Wrap In Chart Category Axis
Jan 12, 2008I do not seem to be able to consistently control word wrapping in the Category Axis area in the series of charts I create quarterly. The individual names appearing are basically the same, but sometimes they word wrap and sometime they don't. In the attached sample, sheet C2-Location: PPO chart is just the way it needs to be - NO WORD WRAP. But if you change that chart to another location it word wraps. (To change locations, go to sheet D2 which controls sheet C2 chart, and change the location to SGO.) It appears that the less bars in the chart the greater the problem.
I have spent 2 1/2 hrs trying to get in control of this. I have changed font sizes, changed the plot area, changed the grid lines scale, changed the cell size on the originating sheet (D2), removed the check mark in Auto Scale on the Font tab, and stretched/reduced the entire chart without consistent success. What is most frustrating is that twice I have "accidently" gotten a chart to all of a sudden not word wrap but don't know why because when I try to repeat what I think I did before, it does not work!
Additionally, at times it may appear correct on the screen, but when I do Print Preview, it is word wrapped! I have searched multiple sites and googled multiple Excel solutions as well as pulled out some books but cannot find any references regarding how to control this.
Prevent To Only Save On Specified Workbook With VBA
Jan 28, 2013am trying to create a workbook template which collects data from users with user forms and some macros. Users assign a project name when workbook opens and then they are able to save as the workbook with name of project name. But i don't want them to save on my template mistakenly. How do i prevent this? I tried workbook_before close sub but i can manage that it recommends to save workbook with project name and if you don't want, it still asks you if you want to save workbook before close
View 7 Replies View RelatedPrevent FILE SAVE
Nov 28, 2007I want to make sure that the user of a file only saves from a button on a particular sheet. Can I ensure that if the user goes File Save at any time that they cannot use it?
View 9 Replies View RelatedMacro To Prevent 'save-as'
Feb 21, 2002Is there any way to write a macro which can prevent computer illiterate users from saving their files EVERYWHERE??
View 9 Replies View RelatedSave Today() As Value To Prevent Changes On Reopen
Jul 30, 2008I have a spreadsheet that containt a conditional formula to place the current date aka Today() into a cell based on if an entry in the previous cell.
I put in this formula:
=IF(I131>="1",TODAY()," ")
My boss told me to update to this one: (same result)
=IF(I130>="1",DATE(YEAR(TODAY()),MONTH(TODAY()),DAY(TODAY()))," ")
BOTH will change the saved sheet data if we open it tomorrow (due to using Today()). We want to retain the date that it was entered on (which will always be the date he puts entry into sheet).
Is there a way to save the sheet and update the code for Today() to the date value so it will appear as a date when it's opened in the future?
Prevent Save Option If Condition Not Met
Sep 28, 2006I have a list dropdown from cells A2 to A10. If only when a user selects "orange", he has to key in some description in column B.
Eg if he selects orange in A2, he has to key in some description in B2.
Is it possible to set some formula or macro which prevents user to save this file if he leave blank in B2 or B10, depending on which row he has select "orange"?
Prevent Save As Version Message
Oct 17, 2006I have an extensive application which I wrote using Excel 2002 (XP - Version 10). However it will likely be used on anything ranging from 2003 - 1997. When I tested it using Excel 97 it gave me the traditional [annoying] message asking if I was sure I wanted to save it under an earlier version than which it was created.
I want to get rid of this message (a lot of my users aren't the most computer literate and the more annoying messages I can avoid the better!)
I tried using:
Application.DisplayAlerts = False
but it doesn't affect this particular message. I need to know how to keep this message from popping up. Please Help.
Under 97 (NOT on my 2002) it also gives a "Do you want to save the changes" message upon closing even though the "DisplayAlerts" is set to false. I'm not sure why this is still coming up.
Prevent Saving Certain Worksheets On Save As
Jan 19, 2008In my program I have prevented the user from saving the Workbook with the following code
Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean)
Dim p As String
Cancel = True
Do While Cancel = True
p = InputBox("Enter password to save file:", "Password Required To Save", "")
If p = "Enter Password Here" Then
Cancel = False
Else
yn = MsgBox("Wrong password. Try again?", vbYesNo, "Invalid Password")
If yn = vbNo Then
Exit Sub
End If
End If
Loop
End Sub
I also need to prevent the user, when they use the save as, from saving certain worksheets. Ex: There are 6 worksheets in the workbook. I only want them to be able to save the first three. Issues: One of the workbooks that I want to allow them to change has a tab name that changes frequently.
Prevent Workbook Save But Allow SaveAs
Jun 24, 2008I've got a workbook that I want to keep intact in a central location on our local network, to make it easier for everybody to access, but don't want people to be able to save changes to the master workbook itself. I'd like to be able to disable the 'Save' feature while still allowing 'SaveAs'. The following code (installed in ThisWorkbook) results in the OPPOSITE of what I'm trying to accomplish (i.e., it allows 'Save' but disables 'SaveAs'):
Private Sub Workbook_BeforeSave(ByVal SaveUI As Boolean, Cancel As Boolean)
If SaveUI Then
MsgBox "The 'Save' function for this workbook has " & Chr(10) & "been disabled. Please use 'Save As'.", vbOKOnly + vbInformation, "Save Disabled"
Cancel = True
End If
End Sub
Obviously I'd also like to check the filename they're performing the 'SaveAs' under and disallow it if it matches the master filename.
I've thought about making the workbook into a template, which would sort of accomplish the same thing, but it would be much easier to just keep it as a workbook.
Prevent Save Until Save As Used
Mar 21, 2008I am trying to hide/grey SAVE option from the menu bar and reset menu back to normal after Save AS has been used.
I was able to do disable SAVE using the following code.
Application. CommandBars("worksheet menu bar").Controls("File").Controls(4).Visible = False
But
the SAVE icon on the Standard toolbar still exist. Is there any way I can disable it and also prevent CTRL. S being used.
Second part of the question.
Once I use Save as I would like menu to be reset back to normal.
Prevent Hidden Columns From Showing Up When I Save It As A Txt File.
Mar 20, 2009When I am saving my spreadsheet as a text file, I have 1 column with formulas that I would like to not show up in my text file. I have tried hiding the column, and have Googled for awhile now.
View 2 Replies View RelatedSave To Word
Apr 15, 2007I have on sheet 1 of my workbook titled "Self Audit" two pages that have been formatted with questions, and a comments page to put reasons for any descrepancies. Since everyone in my department seems to be more familar with word documents I was wondering how to via VBA put these two pages into a word document that they can type into. Is there a way to do this? I tried a simple copy paste just to see how it would work and I can type but it stretches it into 3 pages.
View 3 Replies View RelatedSave Word Document As PDF?
Sep 28, 2013Amend this code? I want to save the word document, then save it as a pdf file, then delete the word document;
Code:
Sub E_W()
Dim strDate As String
Dim DirName As String
[Code]....
Create New Word Document From Template And Save As
Jan 21, 2014I have been working on the following VBA code, which should copy specific charts from excel into specific places in a word-template.
I Am quite new with VBA, so I googled the code, changed a few things, and it works exactly as it should - except from one thing. When the Word-document is loaded from the template, I would like the document to be "saved as..."
Instead of just opening the template. I have tried
Code:
.ActiveDocument.SaveAs Filename:=fname & ".doc"
The code is as follows:
Option Explicit
Sub EksporterTilWord()
Dim appWrd As Object
Dim objDoc As Object
Dim FilePath As String
Dim FileName As String
[Code] ...........
Excel 2010 :: VBA Save AS (word Document) Not Working
Nov 8, 2012I have a long bit of code that at one point saves a Word document and then saves it again with a new name and the old (legacy) .doc extension.
This all works find when the user is running Office 2007. However, it errors out for using Office 2010. The reference libraries are all correct (as far as I know).
Code:
Dim myDoc As Word.Document
Dim saveAsName as String
saveAsName = "some text here" + ".doc"
myDoc.Save
myDoc.SaveAs fileName:=(saveAsName), FileFormat:=wdFormatDocument
Copy Text From Word Doc - Write And Save Workbook
Jan 12, 2013I'm using a code to copy text from a word doc into a spreadsheet. It does it all right, but when it comes to saving, it does not save the open worksheet and prompts me to save as a copy. If I do so, nothing is changed in the original file and the copy file has the information copied from the word file.
This is the code I'm using to write and save the spreadsheet.
...
(VBA in WORD)
Set wdApp = Excel.Application
Workbooks.Open FileName:="C:UsersljsDocumentsword2excel.xls"
Workbooks("word2excel.xls").Activate
Worksheets("Plan1").Activate
Worksheets("Plan1").Range("A2").Value = DOCname
Worksheets("Plan1").Range("B2").Value = CarNo
Worksheets("Plan1").Range("C2").Value = WordNo
ActiveWorkbook.Save
ActiveWorkbook.Close
...
Save Word Document With Current Date From Within Module
May 5, 2006I am using a module to create and save a Word document from an Excel module. I'm using the following line to save the document which works fine but (and this is a big BUT)(to quote a TV programme from long ago) obviously everytime I save the document it will overwrite itself. Is there a way of adding the date it is saved on to the file name so it creates a new document each time.
objWordDoc.SaveAs Filename: = "WAGReport"
I have tried changing it like this but get an error message
Dim dtMyDate As Date
dtMyDate = Format(Date, "DDMMYY")
dtMyDate = Sheets("Client Master").Range("d2")
objWordDoc.SaveAs Filename: = "WAGReport" & dtMyDate
Macro To Hide Cut,copy,paste,save,saveas Option In Word
Feb 15, 2007I want to restrict users to just read or print a word document. Document is very confidential so we dont want them to copy or manipulate the document.
I thought of giving password to restrict to read only option but that still lets users to copy and paste on to a new document.
Prevent Save Unless All Cells Or Certain Cells Are Filled In
Dec 2, 2007I have a spreadsheet that is emailed to someone to fill in. They then fill in some information and send it on to someone else.
Sometimes they don't fill in all the information so is it possible to have excel check that cells are filled in and to prevent someone from saving unless this is so? Or maybe a message stating that the cells need to be completed if Excel is being closed or saved?
Opening Word & Count Word Instances In A Word Document
May 26, 2006I have an excel program that is supposed to count word instances in a word document. I can't seem to find the right declaration for a word document.
For example to declare a workbook in excel its
Dim wb As Work Book
I've tried
Dim doc As Word.Document
'or
Dim doc As Word.Application
as shown in some of the forum posts, but an error user-type not defined keeps displaying.
Export Cell Contents To Word Fields In A Protected Word Document
Jul 6, 2009Is it possible to export Excel cell contents to Word fields in a protected Word document? For example...
What code would be needed to tell Excel to open up, copy and export the contents of A2 in the active sheet of a workbook to "Field 2" in a Word document named "Report 01" and then put the contents of B2 to "Field 2" etc?
Do both applications have to be opened up at the same time or is Excel able to open up Word on its own? Will the macro be able to....
1. Automatically open up the correct Word document?
2. Look ONLY in a certain folder for the "Report 01" Word document?
or
Bring up a "selection" box that allows you to select the document you wish Excel to export it's data to?
3. Close and save the Word Document without any user intervention?
Excel 2003 :: Count How Many Times A Word Is In A Range / Word Can Be In Cell More Than Once
Feb 16, 2012I need to count how many times the word Test is in the range B4:H9 with
Range N2 = Test the formula below works if Test is only in the cell once.
=COUNTIF($B$4:$H$9,"*" & N2 & "*")
But I have data in cells like below, this is all in one cell, so how would I have it count all the times test is in the range when some cells have test 2 or more times in a single cell?
5
Test
8am-2pm
Test
5pm-10pm
Using The IF Function, To Make Entering A Word, Space Then Word Correct
May 6, 2009How can I use the IF function, to make entering a word, space then word display correct and incorrect if not.
View 13 Replies View RelatedHow To Search For A Word In A Column And Have Entire Row Opaque Once Word Is Found
Sep 3, 2009I need my macros to search for the word "Cancel" or "Cancelled" in columns "T" and "U". Once found, I need the macros to make that entire row an opaque shading.
There will be other wording in these cells that contain "Cancel" or "Cancelled". Is it possible for the macros to search in the sentence and find the words "Cancel" or "Cancelled"
I started on the code below but am stuck.
Find A Certain Word In A String Then Return The Number Associated With That Word
Jun 9, 2009Have problems using find and the Dictionary
What Im trying to do is find a certain word in a string then return the number associated with that word
Pick Word From Excel Search In MS Word And Replace All
Jan 4, 2012I am trying to automate the below process:
1. I have a excel file with Japanese words in column A and their English equivalents in column B.
2. I am trying to create a Macro and assign it to a button. On pressing the button Macro should be able to:
3. open a form where I can enter location of a word file.
4. Macro should open the word file specified in (3).
5. Macro will pick up first Japanese word from excel file (Sheet 1 - A1)
6. Search for that word in Word file
7. Replace the Japanese words in Word file with their English equivalent from excel (B1)
8. Then it should search for second word (A2) and replace with its equivalent (B2) and so on till it reaches last filled cell in excel file column A.
After a lot of search I could find a code from net (Below), made a few changes, but it is not working.
========================================================
Private Sub OK_Click()
' Requires a reference to Microsoft Word xx.x Object Library
Dim sFile As String
[Code]....
How To Find Specific Word And Sum The Column According To That Word
Mar 14, 2014I would like to have a formula find a specific word in column L and return the sum from column E for the same fund from column C.
I tried using =SUMIF(L:L,"*annual*",E:E) but that gives me the sum of annual for the entire column. I need to be able to specify the fund.
word "annual" also appears in "semi annual" so I need to be able to separate the two.
Searching For Word Copy Word To Different Column
Jan 22, 2013I want to say if the word 'suitcase' is in column W (any row), place the word 'suitcase' in column Z, same row.
View 2 Replies View RelatedReplace Word In MS Word With Varable From MS Excel
May 1, 2009I am in the middle of automating a process here at work, the program takes a word, "pencil" for example, from excel. It will then open up a word document with content already in it (premade template). The program will then find all instances of a string, "placepencilhere" for example, and will replace that instance with the string from excel.
Basically I want to be able to take a variable that has a stored string value from excel and use it to replace another variable in a word document.
I tried recording a replace (ctrl+f, replace tab) macro, copying the code, and inserting it into the excel vba code.. but I get a error message. Here is what I have:
---