Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Save AS in Excel 2003
I have several users who access the same spreadsheets. Recently, I've had a
problem where a user will have 2 spreadsheets open at the same time and they will accidently some how overwrite one of the spreadsheets with the content of the other spreadsheet that is open. Is their a way to make the "Save As" feature unavailable for these spreadsheets? For example they have a spreadsheet "phonelist" and a spreadsheet "Daily Staffing", both are open at the same time. Some how the contents of "phonelist" replaces the contents of "Daily staffing" and the orignal contents of "Daily Staffing" are gone. I am guessing they are doing a "Save As" but I am not sure. Any suggestion on how to keep this from happening would be greatly appricated. Sincerely, Susan |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Save AS in Excel 2003
Oh i forgot one important detail. The users do need the ability to make
changes to the spreadsheet. "sbhayes" wrote: I have several users who access the same spreadsheets. Recently, I've had a problem where a user will have 2 spreadsheets open at the same time and they will accidently some how overwrite one of the spreadsheets with the content of the other spreadsheet that is open. Is their a way to make the "Save As" feature unavailable for these spreadsheets? For example they have a spreadsheet "phonelist" and a spreadsheet "Daily Staffing", both are open at the same time. Some how the contents of "phonelist" replaces the contents of "Daily staffing" and the orignal contents of "Daily Staffing" are gone. I am guessing they are doing a "Save As" but I am not sure. Any suggestion on how to keep this from happening would be greatly appricated. Sincerely, Susan |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Save AS in Excel 2003
maybe these instructions do the job :
at start up : CommandBars("File").Controls(5).Visible = False 'save as CommandBars("File").Controls(6).Visible = False 'save html closing down: CommandBars("File").Controls(5).Visible = True 'save as CommandBars("File").Controls(6).Visible = True 'save html robert www.allocator.nl sbhayes schreef: I have several users who access the same spreadsheets. Recently, I've had a problem where a user will have 2 spreadsheets open at the same time and they will accidently some how overwrite one of the spreadsheets with the content of the other spreadsheet that is open. Is their a way to make the "Save As" feature unavailable for these spreadsheets? For example they have a spreadsheet "phonelist" and a spreadsheet "Daily Staffing", both are open at the same time. Some how the contents of "phonelist" replaces the contents of "Daily staffing" and the orignal contents of "Daily Staffing" are gone. I am guessing they are doing a "Save As" but I am not sure. Any suggestion on how to keep this from happening would be greatly appricated. Sincerely, Susan |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Save AS in Excel 2003
extra detail wich might help :
block control s (save) Application.OnKey "^{s}", "" Application.OnKey "^{S}", "" and hide save too CommandBars("File").Controls(4).Visible = False 'save Robnific schreef: maybe these instructions do the job : at start up : CommandBars("File").Controls(5).Visible = False 'save as CommandBars("File").Controls(6).Visible = False 'save html closing down: CommandBars("File").Controls(5).Visible = True 'save as CommandBars("File").Controls(6).Visible = True 'save html robert www.allocator.nl sbhayes schreef: I have several users who access the same spreadsheets. Recently, I've had a problem where a user will have 2 spreadsheets open at the same time and they will accidently some how overwrite one of the spreadsheets with the content of the other spreadsheet that is open. Is their a way to make the "Save As" feature unavailable for these spreadsheets? For example they have a spreadsheet "phonelist" and a spreadsheet "Daily Staffing", both are open at the same time. Some how the contents of "phonelist" replaces the contents of "Daily staffing" and the orignal contents of "Daily Staffing" are gone. I am guessing they are doing a "Save As" but I am not sure. Any suggestion on how to keep this from happening would be greatly appricated. Sincerely, Susan |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Save AS in Excel 2003
I am not exactly sure if I did it right. I no longer have 'Save As' or 'Save
html' on my personal excel 2003, but other users still have the option to perform a 'Save As' when they access this workbook. Is their a way to make it workbook specific? "Robnific" wrote: extra detail wich might help : block control s (save) Application.OnKey "^{s}", "" Application.OnKey "^{S}", "" and hide save too CommandBars("File").Controls(4).Visible = False 'save Robnific schreef: maybe these instructions do the job : at start up : CommandBars("File").Controls(5).Visible = False 'save as CommandBars("File").Controls(6).Visible = False 'save html closing down: CommandBars("File").Controls(5).Visible = True 'save as CommandBars("File").Controls(6).Visible = True 'save html robert www.allocator.nl sbhayes schreef: I have several users who access the same spreadsheets. Recently, I've had a problem where a user will have 2 spreadsheets open at the same time and they will accidently some how overwrite one of the spreadsheets with the content of the other spreadsheet that is open. Is their a way to make the "Save As" feature unavailable for these spreadsheets? For example they have a spreadsheet "phonelist" and a spreadsheet "Daily Staffing", both are open at the same time. Some how the contents of "phonelist" replaces the contents of "Daily staffing" and the orignal contents of "Daily Staffing" are gone. I am guessing they are doing a "Save As" but I am not sure. Any suggestion on how to keep this from happening would be greatly appricated. Sincerely, Susan |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Save AS in Excel 2003
In my conception :
Please built the 'Commandbars' options in your program Who ever opens this file : save as and save as html will not appear. At closing down the program : restore ' visible=true' hth robert sbhayes schreef: I am not exactly sure if I did it right. I no longer have 'Save As' or 'Save html' on my personal excel 2003, but other users still have the option to perform a 'Save As' when they access this workbook. Is their a way to make it workbook specific? "Robnific" wrote: extra detail wich might help : block control s (save) Application.OnKey "^{s}", "" Application.OnKey "^{S}", "" and hide save too CommandBars("File").Controls(4).Visible = False 'save Robnific schreef: maybe these instructions do the job : at start up : CommandBars("File").Controls(5).Visible = False 'save as CommandBars("File").Controls(6).Visible = False 'save html closing down: CommandBars("File").Controls(5).Visible = True 'save as CommandBars("File").Controls(6).Visible = True 'save html robert www.allocator.nl sbhayes schreef: I have several users who access the same spreadsheets. Recently, I've had a problem where a user will have 2 spreadsheets open at the same time and they will accidently some how overwrite one of the spreadsheets with the content of the other spreadsheet that is open. Is their a way to make the "Save As" feature unavailable for these spreadsheets? For example they have a spreadsheet "phonelist" and a spreadsheet "Daily Staffing", both are open at the same time. Some how the contents of "phonelist" replaces the contents of "Daily staffing" and the orignal contents of "Daily Staffing" are gone. I am guessing they are doing a "Save As" but I am not sure. Any suggestion on how to keep this from happening would be greatly appricated. Sincerely, Susan |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
Save AS in Excel 2003
In my conception :
Please built the 'Commandbars' options in your program Who ever opens this file : save as and save as html will not appear. At closing down the program : restore ' visible=true' hth robert sbhayes schreef: I am not exactly sure if I did it right. I no longer have 'Save As' or 'Save html' on my personal excel 2003, but other users still have the option to perform a 'Save As' when they access this workbook. Is their a way to make it workbook specific? "Robnific" wrote: extra detail wich might help : block control s (save) Application.OnKey "^{s}", "" Application.OnKey "^{S}", "" and hide save too CommandBars("File").Controls(4).Visible = False 'save Robnific schreef: maybe these instructions do the job : at start up : CommandBars("File").Controls(5).Visible = False 'save as CommandBars("File").Controls(6).Visible = False 'save html closing down: CommandBars("File").Controls(5).Visible = True 'save as CommandBars("File").Controls(6).Visible = True 'save html robert www.allocator.nl sbhayes schreef: I have several users who access the same spreadsheets. Recently, I've had a problem where a user will have 2 spreadsheets open at the same time and they will accidently some how overwrite one of the spreadsheets with the content of the other spreadsheet that is open. Is their a way to make the "Save As" feature unavailable for these spreadsheets? For example they have a spreadsheet "phonelist" and a spreadsheet "Daily Staffing", both are open at the same time. Some how the contents of "phonelist" replaces the contents of "Daily staffing" and the orignal contents of "Daily Staffing" are gone. I am guessing they are doing a "Save As" but I am not sure. Any suggestion on how to keep this from happening would be greatly appricated. Sincerely, Susan |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
Auto save as an add in Excel 2003 | Excel Discussion (Misc queries) | |||
The SAVE AS... option is gone in Excel 2003 | Excel Discussion (Misc queries) | |||
Excel 2003 - Save As function inserts "Copy of" | Excel Discussion (Misc queries) | |||
when I save a worksheet made in excel 2003 to excel 97, | Excel Discussion (Misc queries) |