Results 1 to 9 of 9

Button to Remove all formulas but keep data

Threaded View

  1. #1
    Forum Contributor
    Join Date
    09-25-2018
    Location
    Grimsby, UK
    MS-Off Ver
    365
    Posts
    149

    Button to Remove all formulas but keep data

    I have a heavily protected workbook that I give to others to use. Once they have filled in the data collected they return the workbook to me.

    I would like to add a password protected button so i can remove all formulas and give them the workbook back with only the data - Included the calculated results based on the data input

    The idea is that there is a button that requires a password (Say "Password") if the password is entered correctly it will pop up saying "remove all formulas" Yes/No options.

    If Yes is selected then all formulas will be removed from the workbook but the data will remain
    If No is selected then the pop up will close and no action is required
    If the password is entered incorrectly there will be a pop up saying "Incorrect Password" and then the pop up will close.

    I just cant get this to work and i've tried a few things. It seems this is beyond me and i'm hoping someone can help.

    Thanks

    **EDIT**

    It's important to add that the sheets within the workbook are all protected.
    Last edited by Kevin Rush; 10-06-2021 at 04:49 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Remove Button (Form Control) Based on Button Text
    By xtinct2 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 04-01-2021, 08:24 AM
  2. [SOLVED] remove formulas and keep data
    By Undo in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-15-2019, 04:49 PM
  3. Macro to Copy Worksheet, Remove Formulas and Data Validation
    By Cardan in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-13-2018, 08:27 AM
  4. Replies: 1
    Last Post: 12-12-2017, 12:49 PM
  5. [SOLVED] Delete button to remove data from multiple sheets at the same time - Any Thoughts???
    By JJFletcher in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 07-22-2016, 07:05 PM
  6. [SOLVED] Button to insert new row, clear data and keep formulas
    By dragosnb in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-24-2013, 07:52 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