Results 1 to 10 of 10

Drop Down List hyperlink to sheets in another workbook

Threaded View

  1. #7
    Forum Contributor
    Join Date
    08-30-2012
    Location
    Malaysia
    MS-Off Ver
    Excel 2007
    Posts
    141

    Re: Drop Down List hyperlink to sheets in another workbook

    I already try and I understand that code. but when i double click at the number, the vba appear this and highlight the "Sheetlist":

    Sheets("Sheetlist").Select
    Range("A1").Select
    
    For i = 1 To Workbooks("Stock Cabinet.xls").Worksheets.Count
       ActiveCell.Value = ActiveWorkbook.Worksheets(i).Name
       ActiveCell.Offset(1, 0).Select
    Next
    Why does this happen?
    Last edited by Cutter; 09-03-2012 at 01:43 PM. Reason: Added code tags

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1