I am trying to modify this code to loop though these specific sheets and clear contents of the selection. I don't thick I can use the recorder to do this? The 2nd piece to this is i would like it to unlock ALL sheets in the workbook (not just those selected) then lock at the end.
Here is the code, any help is GREATLY APPRECIATED!
Please Login or Register to view this content.
Try this:
Please Login or Register to view this content.
Last edited by Olly; 10-30-2019 at 05:43 AM.
let Source = #table({"Question","Thread", "User"},{{"Answered","Mark Solved", "Add Reputation"}}) in Source
If I give you Power Query (Get & Transform Data) code, and you don't know what to do with it, then CLICK HERE
Walking the tightrope between genius and eejit...
Maybe:
Please Login or Register to view this content.
Click the * to say thanks.
@ Olly
Probably typo but last part of code should be
to protect sheets againPlease Login or Register to view this content.
Avoid using Select, Selection and Activate in your code. Use With ... End With instead.
You can show your appreciation for those that have helped you by clicking the * at the bottom left of any of their posts.
Well spotted! Typo indeed. Corrected
That worked! Thanks guys!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks