Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Hi,
I have a spreadsheet that I dont want changed. I have code in the worksheet that prevents the user from saving it. My additional question - is it possible to stop a user from clicking on the worksheet name and changing it? The file is on the network. Thanks for your help. |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
As it's on a network, it may be possible to give users read-only access to
the folder. I'm not usre if this will achieve what you want. The only other alternative doesn't actually stop the user renaming, but prompts them to be sure. That is to set the file as read-only. -- Ian -- "Jeff" wrote in message ... Hi, I have a spreadsheet that I dont want changed. I have code in the worksheet that prevents the user from saving it. My additional question - is it possible to stop a user from clicking on the worksheet name and changing it? The file is on the network. Thanks for your help. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Cell("filename") doesn't update to new filename when do save as. | Excel Worksheet Functions | |||
+ in filename | Excel Discussion (Misc queries) | |||
set filename to <filename-date on open | Excel Worksheet Functions | |||
A calculator for inventory safety stock | Excel Discussion (Misc queries) | |||
To safety merge cells without data destroyed, and smart unmerge! | Excel Discussion (Misc queries) |