#1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 921
Default Filename safety

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   Report Post  
Posted to microsoft.public.excel.misc
Ian Ian is offline
external usenet poster
 
Posts: 238
Default Filename safety

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Cell("filename") doesn't update to new filename when do save as. Louis Excel Worksheet Functions 2 March 22nd 07 07:27 PM
+ in filename mkrefting Excel Discussion (Misc queries) 0 October 24th 06 07:44 PM
set filename to <filename-date on open bob engler Excel Worksheet Functions 2 July 13th 06 05:11 AM
A calculator for inventory safety stock Angelus Excel Discussion (Misc queries) 0 May 10th 06 08:04 AM
To safety merge cells without data destroyed, and smart unmerge! Kevin Excel Discussion (Misc queries) 0 December 30th 04 07:17 AM


All times are GMT +1. The time now is 06:21 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"