Posted to microsoft.public.excel.programming

MM User

external usenet poster

Posts: 27

Global Variables

Hi,

Is it possible to add a sub that can be used to set all variables:

Private Sub Workbook_Open()
Run setvalues
End Sub

Public Sub myvalues()
ProjectTitle = "my Project"
End Sub

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
Global Variables	Karen53	Excel Programming	12	April 16th 08 07:14 PM
Global variables	Ed	Excel Programming	6	November 19th 06 10:55 PM
Global Variables	[email protected]	Excel Programming	0	July 7th 06 10:53 AM
global variables	Mike Archer	Excel Programming	4	May 3rd 06 07:33 PM
Global Variables	Ernst Guckel[_4_]	Excel Programming	2	May 7th 05 11:10 PM

All times are GMT +1. The time now is 11:57 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us