Save AS in Excel 2003

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Oh i forgot one important detail. The users do need the ability to make
changes to the spreadsheet.
 
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:
 
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:
 
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?
 
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:
 
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:
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Open XML Spreadsheets with Excel 2000 1
edited spreadsheet saves as template 9
How do I get excel to open with cursor in same cell as when close 2
Double saving? 8
Format of Cells Changing on thier own 1
Clear a cell's contents when document is saved 2
Save as Command Line 1
Staff Levels 3

Back
Top