Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
SAVE AS
Morning all excel gurus. I have a master excel document and when a user
opens it, i need it to automatically prompt for save as so the master is never touched. Please help. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
SAVE AS
From VBE left treeview double click 'This WorkBook' and paste the below code
to the right code pane. Private Sub Workbook_Open() Me.SaveAs Application.GetSaveAsFilename End Sub If this post helps click Yes --------------- Jacob Skaria "Neil Holden" wrote: Morning all excel gurus. I have a master excel document and when a user opens it, i need it to automatically prompt for save as so the master is never touched. Please help. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
SAVE AS
Hi thanks for that, the trouble i have now is if the user opens the excel
file that they have saved its still asking to save as.. I only want it to show that on the master document, also is they anyway i can stop it from defaulting the save as name? Thanks Jacob. Neil "Jacob Skaria" wrote: From VBE left treeview double click 'This WorkBook' and paste the below code to the right code pane. Private Sub Workbook_Open() Me.SaveAs Application.GetSaveAsFilename End Sub If this post helps click Yes --------------- Jacob Skaria "Neil Holden" wrote: Morning all excel gurus. I have a master excel document and when a user opens it, i need it to automatically prompt for save as so the master is never touched. Please help. |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
SAVE AS
Then check it
Private Sub Workbook_Open() With Me If .Name = "Master.xls" Then .SaveAs Application.GetSaveAsFilename End If End With End Sub -- __________________________________ HTH Bob "Neil Holden" wrote in message ... Hi thanks for that, the trouble i have now is if the user opens the excel file that they have saved its still asking to save as.. I only want it to show that on the master document, also is they anyway i can stop it from defaulting the save as name? Thanks Jacob. Neil "Jacob Skaria" wrote: From VBE left treeview double click 'This WorkBook' and paste the below code to the right code pane. Private Sub Workbook_Open() Me.SaveAs Application.GetSaveAsFilename End Sub If this post helps click Yes --------------- Jacob Skaria "Neil Holden" wrote: Morning all excel gurus. I have a master excel document and when a user opens it, i need it to automatically prompt for save as so the master is never touched. Please help. |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
SAVE AS
You can...Edit the workbook master file name...in the below code...
Private Sub Workbook_Open() If Me.Name < "master.xls" Then _ Me.SaveAs Application.GetSaveAsFilename("") End Sub If this post helps click Yes --------------- Jacob Skaria "Neil Holden" wrote: Hi thanks for that, the trouble i have now is if the user opens the excel file that they have saved its still asking to save as.. I only want it to show that on the master document, also is they anyway i can stop it from defaulting the save as name? Thanks Jacob. Neil "Jacob Skaria" wrote: From VBE left treeview double click 'This WorkBook' and paste the below code to the right code pane. Private Sub Workbook_Open() Me.SaveAs Application.GetSaveAsFilename End Sub If this post helps click Yes --------------- Jacob Skaria "Neil Holden" wrote: Morning all excel gurus. I have a master excel document and when a user opens it, i need it to automatically prompt for save as so the master is never touched. Please help. |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
SAVE AS
Hello again, if the excel sheet = master then prompt for save as else ignore?
Currently that ignores master and asks to save as all other excel sheets. Thanks. "Jacob Skaria" wrote: You can...Edit the workbook master file name...in the below code... Private Sub Workbook_Open() If Me.Name < "master.xls" Then _ Me.SaveAs Application.GetSaveAsFilename("") End Sub If this post helps click Yes --------------- Jacob Skaria "Neil Holden" wrote: Hi thanks for that, the trouble i have now is if the user opens the excel file that they have saved its still asking to save as.. I only want it to show that on the master document, also is they anyway i can stop it from defaulting the save as name? Thanks Jacob. Neil "Jacob Skaria" wrote: From VBE left treeview double click 'This WorkBook' and paste the below code to the right code pane. Private Sub Workbook_Open() Me.SaveAs Application.GetSaveAsFilename End Sub If this post helps click Yes --------------- Jacob Skaria "Neil Holden" wrote: Morning all excel gurus. I have a master excel document and when a user opens it, i need it to automatically prompt for save as so the master is never touched. Please help. |
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
SAVE AS
Yes...I meant so..
Private Sub Workbook_Open() If Me.Name = "master.xls" Then _ Me.SaveAs Application.GetSaveAsFilename("") End Sub If this post helps click Yes --------------- Jacob Skaria "Neil Holden" wrote: Hello again, if the excel sheet = master then prompt for save as else ignore? Currently that ignores master and asks to save as all other excel sheets. Thanks. "Jacob Skaria" wrote: You can...Edit the workbook master file name...in the below code... Private Sub Workbook_Open() If Me.Name < "master.xls" Then _ Me.SaveAs Application.GetSaveAsFilename("") End Sub If this post helps click Yes --------------- Jacob Skaria "Neil Holden" wrote: Hi thanks for that, the trouble i have now is if the user opens the excel file that they have saved its still asking to save as.. I only want it to show that on the master document, also is they anyway i can stop it from defaulting the save as name? Thanks Jacob. Neil "Jacob Skaria" wrote: From VBE left treeview double click 'This WorkBook' and paste the below code to the right code pane. Private Sub Workbook_Open() Me.SaveAs Application.GetSaveAsFilename End Sub If this post helps click Yes --------------- Jacob Skaria "Neil Holden" wrote: Morning all excel gurus. I have a master excel document and when a user opens it, i need it to automatically prompt for save as so the master is never touched. Please help. |
#8
Posted to microsoft.public.excel.programming
|
|||
|
|||
SAVE AS
Thanks Jacob much appreciated.
"Jacob Skaria" wrote: Yes...I meant so.. Private Sub Workbook_Open() If Me.Name = "master.xls" Then _ Me.SaveAs Application.GetSaveAsFilename("") End Sub If this post helps click Yes --------------- Jacob Skaria "Neil Holden" wrote: Hello again, if the excel sheet = master then prompt for save as else ignore? Currently that ignores master and asks to save as all other excel sheets. Thanks. "Jacob Skaria" wrote: You can...Edit the workbook master file name...in the below code... Private Sub Workbook_Open() If Me.Name < "master.xls" Then _ Me.SaveAs Application.GetSaveAsFilename("") End Sub If this post helps click Yes --------------- Jacob Skaria "Neil Holden" wrote: Hi thanks for that, the trouble i have now is if the user opens the excel file that they have saved its still asking to save as.. I only want it to show that on the master document, also is they anyway i can stop it from defaulting the save as name? Thanks Jacob. Neil "Jacob Skaria" wrote: From VBE left treeview double click 'This WorkBook' and paste the below code to the right code pane. Private Sub Workbook_Open() Me.SaveAs Application.GetSaveAsFilename End Sub If this post helps click Yes --------------- Jacob Skaria "Neil Holden" wrote: Morning all excel gurus. I have a master excel document and when a user opens it, i need it to automatically prompt for save as so the master is never touched. Please help. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Save, save as, page setup dimmed out in unprotected excel sheet? | Excel Discussion (Misc queries) | |||
Disable save, save as, but allow save via command button | Excel Programming | |||
How to diasble save and save as menu but allow a save button | Excel Programming | |||
Totally Disabling (^ save ) (Save as) and Save Icon – Which code do I use: | Excel Programming | |||
Why system asks me to save change even after I call save method(VB.NET) | Excel Programming |