Posted to microsoft.public.excel.programming

DRKML

external usenet poster

Posts: 3

Public Variable in ThisWorkbook

I want to declare some public variables as soon as I open the workbook. Can
I do that in "ThisWorkbook" or do I need to put it in a module and have
"ThisWorkbook" Open event call a routine to set the public variables?

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Public variable	Jack	New Users to Excel	4	March 18th 06 09:35 PM
Public variable usage!	Tom Ogilvy	Excel Programming	0	April 14th 04 03:34 AM
Public Variable	Jason	Excel Programming	4	April 12th 04 07:06 PM
Use Checkbox Value or Public Variable?	Stratuser	Excel Programming	2	February 12th 04 02:33 PM
public variable	marwan hefnawy	Excel Programming	1	September 5th 03 08:54 AM

All times are GMT +1. The time now is 03:06 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us