Macros

[Sandy]

Hi

Is it possible to prevent a user from accessing the macros dialog
(Tools>Macro>Macros) box to prevent them running a macro from there.

Sandy

 

[Sandy Mann]

Make the Sub Private Sub ................

then the name will not appear in the dialog box.

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

(e-mail address removed)
(e-mail address removed) with @tiscali.co.uk

 

[Bob Phillips]

I prefer making the module private to the project with

Option Private Module

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

 

[Sandy Mann]

What I actually said doesn't make sense anyway! As Winnie the Poo says,
"Sometimes an idea that seems fine in your mind doesn't look the same when
it is outside and people can walk round it and poke sticks at it."

(XL97) VBA Help doesn't hit me over the head saying that it hides the macro
names although I suppose that it is obvious if you take a second or two to
think about it. Consequently I have never used Option Private Module.

Thanks for the info.

--

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

(e-mail address removed)
(e-mail address removed) with @tiscali.co.uk

 

[Sandy]

Sorry I don't understand - out of my depth - I'll give this a miss for now.

Thanks both anyway.

Sandy

 

[Sandy Mann]

I'm not surprised that you could not understand my post but to use Bob's
suggestion press and hold the Alt key whaile you press the f11 function key
above the QWERTY keyboard. This will take you into VBA. In each module
place the cursor in to the left of the first Sub and type in
option private module
then press the Enter key and the job is done.

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

(e-mail address removed)
(e-mail address removed) with @tiscali.co.uk

 

[Sandy]

Sorry didn't realise you had re-posted. Works well. Thank you
Sandy