carefreeant
New Member
- Joined
- Feb 13, 2018
- Messages
- 10
Hi all,
Bear with me - I am a VBA novice so any help would be appreciated.
We currently have a workbook which has a lot of tabs at the bottom. One of the tabs is called 'Shortcuts'.
I am trying to write a VBA whereby if cell P43 on the 'Shortcuts' tab contains "1" a warning pop-up appears when we open the sheet.
Could anybody help with this please? I have searched through quite a few articles online but cannot quite get the box to work correctly.
Bear with me - I am a VBA novice so any help would be appreciated.
We currently have a workbook which has a lot of tabs at the bottom. One of the tabs is called 'Shortcuts'.
I am trying to write a VBA whereby if cell P43 on the 'Shortcuts' tab contains "1" a warning pop-up appears when we open the sheet.
Could anybody help with this please? I have searched through quite a few articles online but cannot quite get the box to work correctly.