Hi

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

Sandy

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


with @tiscali.co.uk


"Sandy" wrote in message
...
Hi

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

Sandy

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" wrote in message
...
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


with @tiscali.co.uk


"Sandy" wrote in message
...
Hi

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

Sandy

"Sandy Mann" wrote in message
...
Make the Sub Private Sub ................

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


with @tiscali.co.uk


"Bob Phillips" wrote in message
...
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" wrote in message
...
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


with @tiscali.co.uk


"Sandy" wrote in message
...
Hi

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

Sandy

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

Thanks both anyway.

Sandy

"Bob Phillips" wrote in message
...
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" wrote in message
...
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


with @tiscali.co.uk


"Sandy" wrote in message
...
Hi

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

Sandy

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


with @tiscali.co.uk


"Sandy" wrote in message
...
Sorry I don't understand - out of my depth - I'll give this a miss for
now.

Thanks both anyway.

Sandy

"Bob Phillips" wrote in message
...
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" wrote in message
...
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


with @tiscali.co.uk


"Sandy" wrote in message
...
Hi

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

Sandy

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

"Sandy Mann" wrote in message
...
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


with @tiscali.co.uk


"Sandy" wrote in message
...
Sorry I don't understand - out of my depth - I'll give this a miss for
now.

Thanks both anyway.

Sandy

"Bob Phillips" wrote in message
...
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" wrote in message
...
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


with @tiscali.co.uk


"Sandy" wrote in message
...
Hi

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

Sandy