Setting worksheet properties

D

Dave Peterson

Protect the structure of the workbook.

Tools|Protection|Protect workbook

No renaming sheets, no inserting of sheets, no moving of sheets.

But this protection can be broken by anyone who really wants to break it.
 
D

Dave Peterson

What happens when you tried it via Edit|move or copy sheet?

What happens if you just select the range (all the cells) and do edit|copy and
Edit|Paste?
 

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

Renaming worksheet on the basis of workbook name 2
Script entry to add a new worksheet 3
Protecting an Excel worksheet from being renamed 3
Open Specific Worksheet Using Button Form Control in Excel 0
Excel 97 - Prevent Renaming/Deleting Protected Worksheet 4
preventing access to hidden worksheets 3
Renaming wrong worksheet. Why? 3
How do I force user to enter their ID# before filling other data? 1

Top