on 2010 Jun 11 6:27 AM
Hi ,
I have actul data in one sheet and budget data in another sheet .
in Budget sheet .. i have acrual button ...when user clk on actual button it will go to next sheet ( actual data area ) .
How can implement in excel ?
regards,
PSR
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi PSR,
You can use the Record macro functionality to obtain the Macro code for any set of actions you want.
View--> Macro --> Record New Macro (MS Office 2007)
Tools--> Macro --> Record New Macro (MS Office 2003)
Hope this helps,
Regards,
G.Vijaya Kumar
Right click on the button>Hyperlink>Link to : Place in this document > Specify the sheet (Actual sheet).
Hope this helps.
Shoba
Hi Soba ,
Thnaks for reply .
it is working but , i want go to specified cell in another sheet means only once clk on the button it will go my required cell ( input enabled are ).
At the same tome , i want hide controle panes with button with out group and ungroup .
How can aechive above both ?
PSR,
I do not understand you second requirement. However to go to specified cell, you can specify the cell reference in the same dialog where you define the hyperlink.
Hi Shoba ,
i am hiding the control panel .with group ( - symbol ) option and open the control panle expand ( + symbol ) .
i want hide and open through button .
is it possible ?
For that you have to use excel functionality.
Assign the hyperlink to the ACTUAL button giving link og BUDGET Sheet.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.