Setting worksheet properties

  • Thread starter Thread starter Guest
  • Start date Start date
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.
 
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
Prevent Worksheet from being deleted 3
Open Specific Worksheet Using Button Form Control in Excel 0
Script entry to add a new worksheet 3
Protecting an Excel worksheet from being renamed 3
preventing access to hidden worksheets 3
How to assign a worksheet in VBA 3
worksheet codename direct use vs. use in a object variable 9

Back
Top