Hi we are using Hyperion Essbase to upload budget packs to essbase.

The only thin we do is to mark one cell in each sheet in a workbook
choose "Lock" and then "Send". (in essbase add-in (menu))


Is it possible to make a macro which does this for me, something lik
for each sheet in workbook. Mark cell "C2", then "Lock" then "send".


Thank

--
Ctec
-----------------------------------------------------------------------
Ctech's Profile: http://www.excelforum.com/member.php...fo&userid=2774
View this thread: http://www.excelforum.com/showthread.php?threadid=48788

Is there no solution to this problem?


--
Ctech
------------------------------------------------------------------------
Ctech's Profile: http://www.excelforum.com/member.php...o&userid=27745
View this thread: http://www.excelforum.com/showthread...hreadid=487889

I think I can help you, but I'll need a little more information. Can
you attach a sample worksheet with the range you want uploaded
highlighted?


--
rbanks
------------------------------------------------------------------------
rbanks's Profile: http://www.excelforum.com/member.php...fo&userid=2944
View this thread: http://www.excelforum.com/showthread...hreadid=487889