Forum Discussion
.XLSM workbook not showing links in column
What you're encountering is a stricter macro security policy that's been going on for several months. Users will encounter one two things typically:
1) XLSM opens with no prompt to enable macros. Any macro buttons the workbook may have are de-activated and macros cannot be run via developer | macros.
2) XLSM opens with a red banner below the ribbon saying macros have been disabled because the source of the macros cannot be trusted.
The solutions typically involve 1 or more of the following:
1. Trust Center - Enable all macros
2. Trust Center | Trusted Documents - Clear trusted document cache
3. File | Info | Inspect document - clear document properties and personal information.
4. Add the location of the workbook as a trusted location
5. 'Unblock' the file through Windows properties:
Have you considered using the Navigation pane to quickly access sheets?
Patrick2788 Hmm, I'm afraid I looked cross-eyed. Of course the Navigation button is there on my build.