Posted to microsoft.public.excel.programming

No Name

Posts: n/a

public but private variables

how can i make variables public to a particular mobule
(particular project) and still not accessible to other
projects (macros) in the same workbook.

currently i declare variables as Public... as these need
to be used by different procedures in the same macro!

thanks

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 variables	johnny	Excel Discussion (Misc queries)	7	February 27th 08 03:44 PM
Public variables	johnny	Excel Discussion (Misc queries)	2	February 24th 08 05:05 AM
Public Variables	Jerry McNabb	Excel Discussion (Misc queries)	0	February 24th 08 01:26 AM
difference between a private sub and a public function?	Dave F	Excel Discussion (Misc queries)	4	March 16th 07 07:38 PM
Public subroutine called from a private sub	Neil Bhandar[_2_]	Excel Programming	1	January 15th 04 10:23 PM

All times are GMT +1. The time now is 07:09 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us