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

I think I have to ask, why use a macro for this?

It would be much easier to just put a text link in (Edit Paste
Special Paste Link).That would circumvent any issues with a macro.

I think its one of those instances where just because you can do
something with VBA, doesn't mean you should. ;)


--
ljsmith


------------------------------------------------------------------------
ljsmith's Profile: http://www.excelforum.com/member.php...o&userid=30531
View this thread: http://www.excelforum.com/showthread...hreadid=542228