Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 70
Default VBA Code to go to one Bookmark.

I have a Tabe of Contents bookmarked on Page 2 titled Table_Of_Contents

Can someone help me on the VBA code. I have the following written but it
says that the bookmark does not exist.

Private Sub CommandButton1_Click()
Selection.GoTo What:=wdGoToBookmark, Which:=wdGoToFirst
End Sub

As a second question, is it possible to have this command button follow each
page on its own as someone scrolls through the document. It's a 115 page
document and i thought it would be easy for the button to float along each
page on the side.

Thanks.
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 245
Default VBA Code to go to one Bookmark.

I think your question would be answered faster he

http://msdn.microsoft.com/newsgroups... lang=en&cr=US

"Juan" wrote:

I have a Tabe of Contents bookmarked on Page 2 titled Table_Of_Contents

Can someone help me on the VBA code. I have the following written but it
says that the bookmark does not exist.

Private Sub CommandButton1_Click()
Selection.GoTo What:=wdGoToBookmark, Which:=wdGoToFirst
End Sub

As a second question, is it possible to have this command button follow each
page on its own as someone scrolls through the document. It's a 115 page
document and i thought it would be easy for the button to float along each
page on the side.

Thanks.

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
BookMark on a Worksheet clara Excel Programming 2 May 15th 07 05:09 PM
bookmark or hyperlink? swissforestry Excel Discussion (Misc queries) 2 February 22nd 06 06:18 PM
Adding a Bookmark Mark Excel Programming 2 November 12th 05 07:49 PM
bookmark a chart? me Charts and Charting in Excel 3 August 28th 05 01:23 AM
VBE bookmark davegb Excel Programming 2 March 16th 05 07:55 PM


All times are GMT +1. The time now is 08:42 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"