Hello I have the below code, which should show an error msg box and close the two workbooks the macro has already opened when there is nothing to paste.
This is working to well! as in it runs even when there is copied text.
Sheets("Tab 2").Select Range("A1").Select...
I use this code to filter data in my workbook;
Private Sub Workbook_Open()On Error GoTo Errorhandler
Worksheets("Shifts").AutoFilterMode = False
I created a macro that opened & updated links on a password protected master wb linked to 10 slave wb.
See link below:
My current issue is... when I make changes to...
I'm new to using macros and have searched this forum and several other forums for a way to update a password protected master workbook (named "WKLY") linked to 10 other workbooks in the same folder. I tried various VBA codes and due to my inexperience with VBA, I was not able to...