Macro available in all worksheets

Jean Cox · Mar 21st, 2002, 02:58 AM

How can I make a macro available in all excel worksheets by default?

eliW · Mar 21st, 2002, 03:21 AM

Quote:

On 2002-03-21 01:58, Jean Cox wrote:
How can I make a macro available in all excel worksheets by default?

Hi Jean,
Make it a PERSONAL MACRO, so it will be available in all your WORKBOOKS.
Eli

Jack in the UK · Mar 21st, 2002, 03:16 PM

Hi

TO add be careful using Personal in networks, a good and i mean very good IT dept will quash this personal setup on reboot as this is good practice so you loose you work, if thisis not the case then good for this question but draaw into question the network, ok ill be shot for that but that the DIR and location nasty programmers use, remove this and threat gone,

I would check the IT dept defaults that the administrate, and if Excel is corperate network edition (which it should be!) then this will happen. If local access ????? not so good bit will allow this function,

So a fix needed i feel....

The most professional way is to export scripts into default file extentions in the dos atributiry thats ti say -/bas files, these are friendly as apposed to cls and vbs files of cause, can email bas with ease not vbs and cls or exe and com for the VB boys out there, if the security if up to scratch of cause.

Not export and remane to recall the macro, inport into new wkbooks as needed.

This is long winded but totally secure and most of all your IT dept wont pester you.

thisis the ideas behind novel and nt platfroms and sign ins repair custom build to company set defaults, a pain but sadlt thats teh world we live in NASTY... thanks to a few..

Mar 21st, 2002, 03:16 PM	#3
Jack in the UK Board Regular Join Date: Feb 2002 Posts: 3,064	Hi TO add be careful using Personal in networks, a good and i mean very good IT dept will quash this personal setup on reboot as this is good practice so you loose you work, if thisis not the case then good for this question but draaw into question the network, ok ill be shot for that but that the DIR and location nasty programmers use, remove this and threat gone, I would check the IT dept defaults that the administrate, and if Excel is corperate network edition (which it should be!) then this will happen. If local access ????? not so good bit will allow this function, So a fix needed i feel.... The most professional way is to export scripts into default file extentions in the dos atributiry thats ti say -/bas files, these are friendly as apposed to cls and vbs files of cause, can email bas with ease not vbs and cls or exe and com for the VB boys out there, if the security if up to scratch of cause. Not export and remane to recall the macro, inport into new wkbooks as needed. This is long winded but totally secure and most of all your IT dept wont pester you. thisis the ideas behind novel and nt platfroms and sign ins repair custom build to company set defaults, a pain but sadlt thats teh world we live in NASTY... thanks to a few.. __________________ Free Excel based Web Toolbar available here. Jack in the UK J & R Excel Solutions "making Excel work for you"

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 21st, 2002, 02:58 AM	#1
Jean Cox New Member Join Date: Mar 2002 Posts: 6	How can I make a macro available in all excel worksheets by default?