Macro available in all worksheets

Excel Facts

Spell Check in Excel
Press F7 to start spell check in Excel. Be careful, by default, Excel does not check Capitalized Werds (whoops)
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
 
Upvote 0
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..
 
Upvote 0

Forum statistics

Threads
1,213,563
Messages
6,114,329
Members
448,564
Latest member
ED38

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top