+ Reply to Thread
Results 1 to 2 of 2

Custom Modules

  1. #1
    Forum Contributor
    Join Date
    01-29-2008
    Location
    Scotland
    MS-Off Ver
    2003
    Posts
    237

    Custom Modules

    Heres a question?

    While creating my worksheet, i have had to lock the sheet to stop users from playing around with the formule. All is fine so far, then i found out that the spell check has been disabled. So after a search i found out how to create a custom module so that i could creat a custom button for the tool bar to spell check to worksheet. This unprotects the sheet, corrects the spelling and then re protects the sheet. All is good so far.

    But here comes the problem, how do i distrubute the custom spell check button to other users when they download the sheet, cos they cannot insert themselves cos the sheets/workbook is protected ????

    G

  2. #2
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,200

    Re: Custom Modules

    You need to use code to add the custom button for the best results. I recently posted code to create a toolbar, see here
    Hope that helps.

    RoyUK
    --------
    For Excel Tips & Solutions, free examples and tutorials why not check out my web site

    Free DataBaseForm example

+ Reply to Thread

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