Forum Discussion
How to add the Rows and table automatically
- Nov 21, 2022
After downloading the workbook, right-click it in Windows Explorer and select Properties from the context menu. If you see Unblock, click it, then click OK.
You may also want to make the folder containing the workbook a trusted location for Excel (File > Options > Trust Center > Trust Center Settings... > Trusted Locations)
See the attached version. You will have to allow macros.
Right-click the sheet tab and select 'View Code' to inspect the VBA code.
- ajmal_pottekattil_yoousufNov 21, 2022Iron ContributorCould you please guide me how to allow the macros.
- HansVogelaarNov 21, 2022MVP
After downloading the workbook, right-click it in Windows Explorer and select Properties from the context menu. If you see Unblock, click it, then click OK.
You may also want to make the folder containing the workbook a trusted location for Excel (File > Options > Trust Center > Trust Center Settings... > Trusted Locations)
- ajmal_pottekattil_yoousufNov 21, 2022Iron Contributor