How to Declare a global public variable on Macro Button

**faboualfa** · 08-06-2007, 05:03 AM

Hello,

Im not sure how to decalre a global public variable on a macro button I have! I need to declare it and set it to true! Anyone tell me how. This is the code im using.

Please Login or Register  to view this content.

----

Please Login or Register  to view this content.

**royUK** · 08-06-2007, 06:24 AM

Why not

Please Login or Register  to view this content.

**faboualfa** · 08-07-2007, 07:50 AM

Thanks RoyUK. Unfortuantly thats not going to work for what i am attempting to do.

I have a button (that has that macro code above assigned)
What i would like to do is disable save and save as and message saying "Please Use the Button".

From the site I recieved the disable code, it said to set fOK as a global public variable and to set fOK in the button Module as True...Have no clue how to do that!!

**royUK** · 08-07-2007, 08:25 AM

I think this is what you want

Please Login or Register  to view this content.

Then your code will work

**faboualfa** · 08-07-2007, 08:38 AM

Roy UK you are Awesome!!

A great many thanks!

How to Declare a global public variable on Macro Button

LinkBack

Thread Tools

Rate This Thread

Display

How to Declare a global public variable on Macro Button

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions