Disable a worksheet so user cannot mess with

  • Thread starter Thread starter poppy
  • Start date Start date
P

poppy

Goodday All


I would like to know if it is possible to disable a sheet in a workboo
using VBA so that a user is not able to tamper with it?


Kind Regard
 
Hi..

Press Alt + F11 to get in to Microsoft Visual Basic Window..

Select the sheet to be hidden from “Project” window

Select Properties windows and choose “2 – xlSheetVeryhidden” fro
Visible Properties.

Close the window

Note: Go to View option and select Project & Properties window, if i
does not appear by default.

Hope this will take care of your problem
 
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

Disable Worksheet Tab Menu 6
setting an event in an embedded chart from a differnet workbook 1
To protect user's privacy 1
Disable worksheet macros when copying a worksheet in VBA 2
Run a macro when cell changes (due to calculation!) 3
Different password for different worksheet " Help !" 1
Delete all blank worksheets? 2
Open Multiple Workbooks or Worksheets 1

Back
Top