Results 1 to 10 of 10

Active Buttons required

Threaded View

  1. #1
    Forum Contributor
    Join Date
    03-23-2007
    Location
    Essex, UK
    MS-Off Ver
    MS365 V2308
    Posts
    279

    Active Buttons required

    Well im back for another lesson on VBA. Ive tried to get this to work from what I've learnt in previous posts but I just keep screwing it up, so I have included the workbook with the buttons added but not active. What I need is some help on how to get them to do what I want.

    The buttons are located on the PFM Tracker sheet with what I need them to do. In addition I'll give you a breakdown of what is required.

    Currently when the workbook is opened the user is forced to activate the macros. One of these macros disables the Cut, Copy Paste features within Excel. I need the first button 'Enable Copy' to request a password for activation and once entered the Cut, Copy, Paste feature to be enabled. Then when finished the 2nd button 'Disable Copy' when clicked to re-activate the Cut, Copy, Paste Disabled macro.

    Hope that explains it. I have left the PFM Tracker sheet unprotected for who ever wants to play with it. (Not that protection would stop some)

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