Results 1 to 4 of 4

How to make your Excel 'Options' choices persistent?

Threaded View

  1. #1
    Registered User
    Join Date
    10-27-2014
    Location
    UK
    MS-Off Ver
    Office 10
    Posts
    27

    How to make your Excel 'Options' choices persistent?

    I've a workbook that uses images embedded within pop-up Comments to help users navigate around and use the spreadsheet.
    But when I share the workbook with others, it appears that the default comment visibility (set in 'Options', Advanced, Display to either 'No Comments or Indicators', 'Indicators only, and Comments on Hover', or 'Comments and Indicators') is determined by that user's own Excel settings, rather than being 'stored' within the workbook itself.

    I obviously want to ensure (force!) my users to see the helpful comments - and not to inadvertently miss them by having their Options inappropriately configured.

    Is there a way I can 'store' Excel option settings within a workbook itself so as to over-ride an end-users default preferences?
    Would / could I have to do that by writing a little VBA code in the Workbook_Open() event?

    Thanks for your advice,

    MathUKTeacher


    BTW, I'm using Office 10, 32-bit - but my workbooks are used on 32 and 64-bit machines with Office 13 too.
    Last edited by MathUKTeacher; 01-11-2015 at 02:21 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Excel 2007 Persistent tab for Add-in or macros book
    By vicsar in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-04-2014, 09:57 AM
  2. How to make choices in a combo box from a macro?
    By Mojave in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-01-2010, 06:46 PM
  3. Make clicked button go bold and other choices go gray
    By szfoster in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-20-2009, 03:41 PM
  4. [SOLVED] Format from menu will not offer options or choices?
    By Tribeventure in forum Excel General
    Replies: 0
    Last Post: 12-06-2005, 04:20 PM
  5. Persistent menu item with Excel Automation Add-in?
    By srplatt@yahoo.com in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-10-2005, 02:06 PM

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