Prev: .Formula vs .FormulaR1C1 in 2007
Next: Validate to quarter units
From: joemeshuggah on 25 Feb 2010 13:12
how can one prevent a user from

1. deleting a specific tab in a workbook?

2. prevent a user from running a macro from the tools menu (where user can
only run a macro from a command button)?

thanks!
From: Dave Peterson on 25 Feb 2010 13:34
#1.

Protect the workbook's structure.

In xl2003 menus:
tools|protection|protect workbook|check structure

#2.

Make the sub private:

Sub Testme()
becomes
Private Sub testme()

This will stop the user from seeing that subroutine--but if they know the name,
they can still type it and run it.




joemeshuggah wrote:
>
> how can one prevent a user from
>
> 1. deleting a specific tab in a workbook?
>
> 2. prevent a user from running a macro from the tools menu (where user can
> only run a macro from a command button)?
>
> thanks!

--

Dave Peterson
From: Barb Reinhardt on 25 Feb 2010 13:51
1. deleting a specific tab in a workbook? PROTECT the workbook.

2. prevent a user from running a macro from the tools menu (where user can
only run a macro from a command button)? Maybe you could tweak the macro
to ensure it's being run on the correct worksheet. To prevent it from the
tools menu can be a bit complicated.
--
HTH,

Barb Reinhardt



"joemeshuggah" wrote:

> how can one prevent a user from
>
> 1. deleting a specific tab in a workbook?
>
> 2. prevent a user from running a macro from the tools menu (where user can
> only run a macro from a command button)?
>
> thanks!
 | 
Pages: 1
Prev: .Formula vs .FormulaR1C1 in 2007
Next: Validate to quarter units