Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
draw button
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
draw button
It seems to me it might be easier to implement this as a custom toolbar
button rather than a command button. For one thing, you only need to create the button once. Your code will need some way of tracking which sheet the user came from, though - not sure how you are currently doing this. If you are not familiar with custom toolbars, check the Excel Help file for basic info; if you need details on VBA coding, here's a good start http://msdn.microsoft.com/library/de...ommandbars.asp (for Excel 2000 at least) "Valeria" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
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 |