Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Dear experts,
I have a workbook with many sheets and charts, that needs to be used by many users. In the first sheet I have put the instructions/explanations and hyperlinks to go to the other sheets and charts, but once my users are there, how can they go back? I have thought about "back" buttons: this is OK for the charts, because I can find some room on them without hiding the graphs. Only I don't know how to draw a button on a chart from VBA, the "normal" code for sheets does not seem to work. The second issue is that the "normal" sheets are full of data: if I put a "back" button there, users won' be able to see the content of at least one cell (unfortunately I can't modify the format of the sheets to add a row or column). Do you have any experience/suggestions to give me? I am very new to developing spreadsheets for many users (and not very good at VBA!), and I am really scared my users might get lost bewteen sheets. As usual, many thanks, without this site and your precious help I would not be able to learn effectively how to use VBA and Excel! Best regards, -- Valeria |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How can I draw a check box or a radio button in excel? | Excel Discussion (Misc queries) | |||
Draw tool bar | Excel Discussion (Misc queries) | |||
How do I draw a line of best fit? | Charts and Charting in Excel | |||
Draw Buttons | Excel Programming | |||
Excel's draw tool to create a Macro Button | Excel Programming |