Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
In changing our Hyperion s/w over to another server,
our IT has told us (users) that if errors occur they are due to Macros being present in our active excel file (??&^%&^%)... and if present, we must perform some additional work,, modification having to do with re-selecting the members..(??) - in order to fix.. Someone asked me, "how do I know if I have a macro?" From the standpoint of "ease" and in that order I said you could begin determining that by: From any open current excel file (in order of ease - and note that first couple do not guarantee you don't).. 1) From Spreadsheet - do Alt+F8 - Only Partial answer 2) From Spreadsheet - do Alt+F11 - Get to the Project Explorer window and double-click on a) each sheet object, b) the ThisWorkbook object and ) any Standard modules 3) While in VBE - Project Window there of course can be 1) a Personal.xls; or 2) Other Currently Open Workbooks; 3) Various AddIns.. After that, I'm not sure what to offer. Any advise on what else should be considered here. Any Help appreciated, Jim |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Macro, shortcut keystroke for Hyperion Add-In | Excel Discussion (Misc queries) | |||
Range Name affecting speed of macro | Excel Worksheet Functions | |||
Hyperion Essbase add-in macro | Excel Programming | |||
Macro for Hyperion | Excel Worksheet Functions | |||
Macro to connect excel sheets automatically to Hyperion ESSBASE 6.5 | Excel Programming |