Workbook protection with enable macros

  • Thread starter Thread starter lud1
  • Start date Start date
L

lud1

Hi All,
I am very beginner macro creator and need your help. I create
woorkbook with two sheets and some macros what transfers data from th
first sheet (A) to the second one (B).
The A sheet will be fulfilled by several people and everytime dat
transfered to B and save with the same name. Additionally the A shee
will be coppied to the new woorkbook and saved with new name.
I would like to create a macro or something what protects A shee
against formating, B sheet against changes and macros agains
displaying.
Is it possible ?
Thanks in advance for your simple replies.
lud
 
Hi, Lud.

lud1 > said:
Hi All,
I am very beginner macro creator and need your help. I created
woorkbook with two sheets and some macros what transfers data from the
first sheet (A) to the second one (B).
The A sheet will be fulfilled by several people and everytime data
transfered to B and save with the same name. Additionally the A sheet
will be coppied to the new woorkbook and saved with new name.
I would like to create a macro or something what protects A sheet
against formating, B sheet against changes and macros against
displaying.
Is it possible ?
Thanks in advance for your simple replies.
lud1
Click to expand...

You can keep your macros from displaying in the VBE window. In the Project
Explorer pane, right-click on the Project name for the workbook. Select
Properties, and select the Protection tab. There's an option there to Lock
Project For Viewing. Check the box and insert password.

Protecting the sheets can get difficult, depending on your users. If you
have users who like to mess around with things just because they can, life
can be hard! On the other hand, if you just want to keep out the clumsy
keystrokes, it's not too bad.

A simple way to protect your Sheet B might be to make it VeryHidden. That
way, it doesn't show up in the menus to be unhidden. If they don;t know
it's there, they can't play with it.

For Sheet A, you seem concerned about protecting the formatting only? What
kind of changes are you concerned your users might do? Simple protection is
done by selecting the entire worksheet and making sure the cells are all
locked (Ctrl+1, Protection tab), then going back and unlocking just the
individual cells your users will use to input data. Once you've finished
that, go to Tools>>Protection>>Protect Sheet. You can put in a password
here, too, if you like.

When you've got that all done, you can go back to Tools>>Protection and
select Protect Workbook.

If you need more information on these, check out the Visible Property in VBA
help, and Protect workbooks and worksheets from changes in Excel help. Post
back if you have problems.

HTH
Ed
 
Back
Top