Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Can I disable the Save As Function?
Hi
I have a spreadsheet for daily task sheets, there is a tab for each day of the month (30/31 tabs). There will be a group of users using this worksheet and the majority of info in it is srop down boxes, but I only want them to be able to use the Save function - I dont want to give them the option to 'Save As' or I want the 'Save As' not to work. Any help on if and how I can set this up would be gratefully received Amy |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Can I disable the Save As Function?
Hi
I have a spreadsheet for daily task sheets, there is a tab for each day of the month (30/31 tabs). There will be a group of users using this worksheet and the majority of info in it is srop down boxes, but I only want them to be able to use the Save function - I dont want to give them the option to 'Save As' or I want the 'Save As' not to work. Any help on if and how I can set this up would be gratefully received Amy This will require using VBA to disable when the workbook opens, enable before the workbook closes. Ideally, though, it would be best to use a Class module so that toggling SaveAs only occurs when that workbook is active. This makes SaveAs available normally for all other open files. -- Garry Free usenet access at http://www.eternal-september.org Classic VB Users Regroup! comp.lang.basic.visual.misc microsoft.public.vb.general.discussion |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can you disable the save function from a shared workbook | Excel Discussion (Misc queries) | |||
Disable save, save as, but allow save via command button | Excel Programming | |||
How can I disable the save function depending on one cell? | Excel Programming | |||
Disable save function | Excel Discussion (Misc queries) | |||
Disable save Function | Excel Discussion (Misc queries) |