Filename safety

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

Guest

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.
 
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.
 
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

problems getting this macro to work 23
VBA - retrieve data on last create named range from previous inserted named range 0
Save spreadsheet using cell values as filename 1
Freeze filename and path in cell 2
Allowing user to choose to accept saveas option 4
Using filename retrieved from GetOpenFilename 1
Extracting xlsx data from structured Storage 0
Sheet Names and Auto-calculation 2

Back
Top