View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
kassie kassie is offline
external usenet poster
 
Posts: 268
Default Creating a button + Issue w/ digital signing

You can actually use a rectangle from the Draw toolbar, or even a textbox. I
normally set the textbox line colour to black, and I use a fill colour to
make it stand out. You write a macro to go to the desired month - by
referring to range names, and then assign this macro to the relevant textbox.
Right click on the textbox, and select assign macro.
Use selfcert.exe to create a digital signature, which you then use to sign
your macros with, and you are A for away!

"WLMPilot" wrote:

This question is two part. I have a workbook that I have set up 12 sections
within one sheet. The worksheet is named "2006". The sections are Jan -
Dec. I have set up a section for each month and will use to balance my
checkbook instead of having to write each uncleared check down then add them
up, along with the other calculations. That said, I want to create a button
in column A for each month so that I can click on the month and it will jump
to that month in the same worksheet.

Part 1): How do I create the button?

Part 2): Having tried to create the button already, I run into an issue
with digital signing and certification regarding macros. Do I really have to
go through this part? If so, what is the best way to go about doing it? If
not, how do I get around it?

Thanks,
Les