Results 1 to 13 of 13

Macro to unlock on click, display certain column data and refresh data

Threaded View

justin1202 Macro to unlock on click,... 12-18-2015, 11:01 PM
xladept Re: Macro to unlock on click,... 12-19-2015, 01:39 AM
justin1202 Re: Macro to unlock on click,... 12-19-2015, 09:39 PM
xladept Re: Macro to unlock on click,... 12-19-2015, 09:50 PM
justin1202 Re: Macro to unlock on click,... 12-20-2015, 11:25 PM
xladept Re: Macro to unlock on click,... 12-21-2015, 01:37 AM
xladept Re: Macro to unlock on click,... 12-21-2015, 12:19 AM
justin1202 Re: Macro to unlock on click,... 12-21-2015, 12:27 AM
justin1202 Re: Macro to unlock on click,... 12-21-2015, 06:20 AM
xladept Re: Macro to unlock on click,... 12-21-2015, 12:07 PM
justin1202 Re: Macro to unlock on click,... 12-21-2015, 05:39 PM
justin1202 Re: Macro to unlock on click,... 12-21-2015, 05:41 PM
xladept Re: Macro to unlock on click,... 12-21-2015, 10:02 PM
  1. #1
    Registered User
    Join Date
    07-01-2015
    Location
    Singapore
    MS-Off Ver
    2007
    Posts
    51

    Macro to unlock on click, display certain column data and refresh data

    Hi

    I'm using a Ron de Bruin macro, http://www.rondebruin.nl/win/s3/win006_4.htm

    There is a list of Data on Sheet 1 and I have edited to protect the sheet. Password is 123.
    I want to edit to make the following:
    1) When I click on the button, it will auto unlock the sheet and after running the macro, it will protect back the sheet.
    I have used the macro
    My_Range.Parent.Unprotect "123"
    However, it doesn't seems to be working.

    2) How should I edit such that it will only show certain columns (e.g. Column A and C) instead of all data

    3) Lastly, and how to edit to make the data be refreshed when new data is added or existing data is deleted?

    I have attached the file for reference.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Macro to refresh Essbase data sets, display refresh date?
    By nellaneb in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-17-2014, 03:59 PM
  2. [SOLVED] Unlock a range of cells in a column ONLY when the first cell of that column has data.
    By damienchew in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 01-13-2014, 12:14 AM
  3. Refresh data automatically - List only the data where one specified column is blank
    By swagatam2014 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-23-2013, 12:56 AM
  4. Pivot - display source data filename after refresh
    By FerdieB in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 09-05-2012, 03:19 AM
  5. Refresh UserForm to display data that is linked to combobox selection
    By alter54 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 08-16-2012, 01:30 PM
  6. Replies: 1
    Last Post: 08-30-2008, 03:57 AM
  7. When I click refresh data virus message appears
    By gmservmgr in forum Excel General
    Replies: 1
    Last Post: 04-12-2006, 07:45 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