close

Hello,

I'm trying to create a macro that simulates some of the toolbar button
(copy, paste,..)
namely, I want to emulate the quot;Backquot; and quot;Forwardquot; button (these button are
part of the web toolbar)
I tried to record a new macro but instead of coding the generic function
quot;backquot; it specifically record the name of the worksheet I should navigate too.

I just want the generic function quot;backquot; in my macro. I will have Back and
Forward button over 10 different worksheet and am using a lot of hyperlink in
them.

Thanks for your advise.
And sorry if this question seems too silly to you. I'm not litterate with
Excel macros.

Perhaps try David McRitchie's page at:
www.mvps.org/dmcritchie/excel/sheetback.htm

--
Max
Singapore
savefile.com/projects/236895
xdemechanik
---
quot;Duangruthaiquot; wrote:
gt; Hello,
gt;
gt; I'm trying to create a macro that simulates some of the toolbar button
gt; (copy, paste,..)
gt; namely, I want to emulate the quot;Backquot; and quot;Forwardquot; button (these button are
gt; part of the web toolbar)
gt; I tried to record a new macro but instead of coding the generic function
gt; quot;backquot; it specifically record the name of the worksheet I should navigate too.
gt;
gt; I just want the generic function quot;backquot; in my macro. I will have Back and
gt; Forward button over 10 different worksheet and am using a lot of hyperlink in
gt; them.
gt;
gt; Thanks for your advise.
gt; And sorry if this question seems too silly to you. I'm not litterate with
gt; Excel macros.

arrow
arrow
    全站熱搜
    創作者介紹
    創作者 software 的頭像
    software

    software

    software 發表在 痞客邦 留言(0) 人氣()