+ Reply to Thread
Results 1 to 2 of 2

Combobox Values when workbook hidden

  1. #1
    Registered User
    Join Date
    05-08-2014
    MS-Off Ver
    Excel 2003
    Posts
    2

    Combobox Values when workbook hidden

    Hello,

    I have a userform with a combobox in it which retrieves values from a named range. It works great when the workbook is visable.

    however I need the end user not to be able to see the database. Im currently using this code to hide the workbook and the row source in the combobox.

    Please Login or Register  to view this content.
    Thanks,
    Michael

  2. #2
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,643

    Re: Combobox Values when workbook hidden

    Perhaps you should try another method of populating the combobox?
    If posting code please use code tags, see here.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Populate Combobox with Worksheet Names EXCLUDE hidden
    By smartbuyer in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 11-28-2013, 11:03 PM
  2. populate a combobox based on unique values in another workbook
    By roninn75 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-03-2013, 03:36 AM
  3. Selecting value in 2D ComboBox by hidden column
    By oblak.luka in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-28-2013, 05:59 AM
  4. combobox - List from 2 colums - but 1 hidden
    By Lkivagten in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-20-2013, 10:09 PM
  5. Primary workbook is hidden when name of hidden workbook changes
    By excel_vb in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-02-2010, 08:05 PM
  6. VBA Function Vlookup data from Hidden sheet in hidden workbook
    By wotadude in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-16-2008, 11:22 PM
  7. Hidden columns NOT HIDDEN on shared workbook
    By Excel Kurt in forum Excel General
    Replies: 2
    Last Post: 07-11-2007, 03:16 PM
  8. Combobox values reference to another workbook
    By Aussie_Striker in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 01-15-2007, 02:13 AM

Tags for this Thread

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