Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Marcro does not work when original workbook is deleted
I have a macro that I want to work using a button that works for any workbook
that the user opens. However, everytime I create the macro and assign it a button it works as long as the orig. workbook that I created the macro in still exists. However if that workbook gets deleted when I open excel and try to use the macro/button it gives an error that it cant fiind the book. I dont want to attach the macro to an excel workbook but rather to just be a standalone for anyone using the excel to be able to use at anytime. I cant seem to be able to create a macro without a workbook open and when I do this it only gives the options for Macros IN: All open workbooks or This workbook. Neither one of these seem to do the job. Do I need to put the macro code in a class or somewhere else for the VB? Have not played with this before so any help would be great.. -- alley |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Marcro does not work when original workbook is deleted
create a personal macro workbook called personal.xls and store in your
XLStart folder (probably in c:\program files\microsoft office\office10\xlstart). open excel and select personal.xls and go to Window Hide. everytime you open excel this xls will open in the background. you can access it through the Visual Basic Editor. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Links doesnt work in the copy version of the original sheet | Excel Discussion (Misc queries) | |||
retreive deleted excell work sheets? | New Users to Excel | |||
to recover deleted work sheet from file | Excel Worksheet Functions | |||
deleted work sheets - Excel | Excel Worksheet Functions | |||
Marcro to copy sheet out of workbook | Excel Programming |