Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Macro with worksheet
Hi,
Does anyone know how to save a worksheet within a macro. I already created a macro and saved it to the excel add ins, I want to save a worksheet to it so that when the macro works on any sheet it uses data from that saved worksheet in it (as a database)? Hope it is clear...! |
#2
|
|||
|
|||
Quote:
Put the worksheet in your addin. To do this open the workbook (the .xlsm version of the addin) and put the worksheet there. Save the workbook and convert it to addin again. Replace this addin with the existing one. You can then write code/formulas that takes an argument from the open workbook and compares it with the worksheet saved within your addin. Does this make sense? If you are not sure, please share the sample addin and what you want to do with it and I can sort it out for you. Thank You, Prashant |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro to name worksheet tabs using a cell within the worksheet? | Excel Discussion (Misc queries) | |||
Macro to Insert Worksheet with Worksheet Name the Current Date | Excel Programming | |||
How? Macro to copy range to new worksheet, name new worksheet, loop | Excel Programming | |||
macro to apply worksheet event to active worksheet | Excel Programming | |||
Record Worksheet Content as Macro and Execute from another Worksheet | Excel Programming |