Creating a button + Issue w/ digital signing

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

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

Thanks for your response. I am new to macros. Can you be more specific as
to how to create this macro. I am aware of the START/STOP recording, but I
am not familiar with what happens in between.

Thanks,
Les

"kassie" wrote:

> 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

Click on Tools|Macros|Record new macro. Now clcik on <Ctrl><G>, select the
address - range name - you want to go to and click OK Click on Stop
Recording. Press <Alt><F11> to go to VBA, and you will see your macro - most
likely named Macro_1.

Say you used this method to record the macro to take you to February. Now
rename this macro to Sub Feb(). Select the text between () and End Sub,
"Application.Goto Reference:="February"" and press <Ctrl><C> to copy it.

Now create a new Macro, say Sub Mar(). On the next line, press <Ctrl><V> to
paste in. Change February to March. You have just created your second
macro. Do the same for the rest.

"WLMPilot" wrote:

> Thanks for your response. I am new to macros. Can you be more specific as
> to how to create this macro. I am aware of the START/STOP recording, but I
> am not familiar with what happens in between.
>
> Thanks,
> Les
>
> "kassie" wrote:
>
> > 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

Thanks for your help Kassie. So far, I have created 12 buttons (each
representing a month of the year) that goes to (ie brings to view) the
appropriate section of the same worksheet.

Now I am trying to have a macro that runs when I click on a button in order
to switch to a different worksheet within the same workbook.

Thanks,
Les



"kassie" wrote:

> Click on Tools|Macros|Record new macro. Now clcik on <Ctrl><G>, select the
> address - range name - you want to go to and click OK Click on Stop
> Recording. Press <Alt><F11> to go to VBA, and you will see your macro - most
> likely named Macro_1.
>
> Say you used this method to record the macro to take you to February. Now
> rename this macro to Sub Feb(). Select the text between () and End Sub,
> "Application.Goto Reference:="February"" and press <Ctrl><C> to copy it.
>
> Now create a new Macro, say Sub Mar(). On the next line, press <Ctrl><V> to
> paste in. Change February to March. You have just created your second
> macro. Do the same for the rest.
>
> "WLMPilot" wrote:
>
> > Thanks for your response. I am new to macros. Can you be more specific as
> > to how to create this macro. I am aware of the START/STOP recording, but I
> > am not familiar with what happens in between.
> >
> > Thanks,
> > Les
> >
> > "kassie" wrote:
> >
> > > 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