Replies

Should be able to use just the name “Start” (without the quotes, although “Start” may be a inadvisable name to use for macro)

Should be able to use just the name “Start” (without the quotes, although “Start” may be a inadvisable name to use for macro)

Obviously “Call” is not part of the Object Library.

Are you trying to Select Sheet3 or Activate? Or is this another macro? If so, you can just use the macro name, and it will run at that point.

Obviously “Call” is not part of the Object Library.

Are you trying to Select Sheet3 or Activate? Or is this another macro? If so, you can just use the macro name, and it will run at that point.

Or you can download the free add-in, morefunc at

http://longre.free.fr/english/index.html%5B/url%5D

Then use =SHEETNAME()

Or you can download the free add-in, morefunc at

http://longre.free.fr/english/index.html%5B/url%5D

Then use =SHEETNAME()

Did you also check to make sure that the linked cell reference was changed on all the second set of buttons? (Right click > Format Control > Control)

Did you also check to make sure that the linked cell reference was changed on all the second set of buttons? (Right click > Format Control > Control)

I’m assuming the file is an Excel file. It isn’t IE that is the problem, it is Excel. Check the Macro Security of Excel.

Unfortunately, I am not able to “fix” the problem. The company does not see fit for me to have Essbase, so I have never used it. And the others who do have it gave up in frustration (they don’t know much VBA, far less than me, and I am still learning). So, it is “unresolved” for them.

My guess would be that you would have to include the Shell function to access Essbase, and you would have to have access to the Essbase Reference Library in VBA; and for the Shell function to work, you will need the TaskID # for Essbase. But that is only a guess.

———————

BTW, on your code, you can most likely eliminate all of the “scroll” lines.

Unfortunately, I am not able to “fix” the problem. The company does not see fit for me to have Essbase, so I have never used it. And the others who do have it gave up in frustration (they don’t know much VBA, far less than me, and I am still learning). So, it is “unresolved” for them.

My guess would be that you would have to include the Shell function to access Essbase, and you would have to have access to the Essbase Reference Library in VBA; and for the Shell function to work, you will need the TaskID # for Essbase. But that is only a guess.

———————

BTW, on your code, you can most likely eliminate all of the “scroll” lines.

Yep. By retrieving it beforehand when you recorded it, you never accessed Essbase. We have several who have had trouble accessing Essbase because they did what you did.

Yep. By retrieving it beforehand when you recorded it, you never accessed Essbase. We have several who have had trouble accessing Essbase because they did what you did.

Also, be sure that you make the change in row 2 and then copy the formula. because if you change onlyrow 6, the references to the proper cells will not be correct.

Also, be sure that you make the change in row 2 and then copy the formula. because if you change onlyrow 6, the references to the proper cells will not be correct.