+ Reply to Thread
Results 1 to 2 of 2

Are data query and sheet protection impossible on the same sheet?

  1. #1
    Forum Contributor
    Join Date
    05-24-2006
    Location
    Los Angeles
    MS-Off Ver
    2019
    Posts
    326

    Are data query and sheet protection impossible on the same sheet?

    Hi,

    Is there any VBA way to use Data Query and keep a column of cells and ActiveX controls protected?

    I just need to keep the user from changing the formulas in columns A & B and a command button. Everything to the right and down from cell C17 is unprotected terrain where the imported data is to go.

    Thanks,

    Lawrence

  2. #2
    Forum Contributor
    Join Date
    05-09-2009
    Location
    London, England
    MS-Off Ver
    Excel 2007
    Posts
    315

    Re: Are data query and sheet protection impossible on the same sheet?

    Hi

    Why don't you unprotect the sheet at the start of your sub and reprotect it when you've finished the data query?

    Dion


    Please Login or Register  to view this content.

+ 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