momentumons
Board Regular
- Joined
- Mar 30, 2020
- Messages
- 57
- Office Version
- 2016
- Platform
- Windows
Hello! I have a model that has two macros in it that both basically copy and paste data. How can I get these to run but also protect the sheets so that no one accidentally makes changes to these (they should be making changes in the master sheets and using the macros to copy the data)...
My FIRST MACROS IS:
Sub REFRESH_DATA_TAB()
'
' REFRESH_DATA_TAB Macro
' ctrl alt f5 - to run the power query
'
'
ActiveWorkbook.RefreshAll
End Sub
(It activates a power query from another workbook)
MY SECOND MACRO IS:
Sub ARCHIVE_FCST()
'
' ARCHIVE_FCST Macro
'
'
End Sub
(It's a series of recorded steps)
Thanks!
My FIRST MACROS IS:
Sub REFRESH_DATA_TAB()
'
' REFRESH_DATA_TAB Macro
' ctrl alt f5 - to run the power query
'
'
ActiveWorkbook.RefreshAll
End Sub
(It activates a power query from another workbook)
MY SECOND MACRO IS:
Sub ARCHIVE_FCST()
'
' ARCHIVE_FCST Macro
'
'
End Sub
(It's a series of recorded steps)
Thanks!