Creating a button + Issue w/ digital signing

[WLMPilot]

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

[kassie]

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

[WLMPilot]

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

[kassie]

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

[WLMPilot]

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

[ljsmith]

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.

[WLMPilot]

I am learning how to do macros. Not sure if you have read my initial
question in this thread, but I am do so because I am trying to learn macros.

"ljsmith" wrote:

>
> 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
>
>

[ljsmith]

I did see the initial question. However, part of the process should be also learning when you should and shouldn't use macros.

In this case, it's like using a limosine to go a half mile distance.

I am learning how to do macros. Not sure if you have read my initial
question in this thread, but I am do so because I am trying to learn macros.

"ljsmith" wrote:

>
> 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
>
>