Last seen: Jun 11, 2026
Hi Jernej, Can you please supply the workbook so we can see what you have done. Regards Phil
Hi Vic, I don't understand what you have done with 'UnprotectAllSheet'. If you can share the workbook with the new code it might offer some clues....
Hi Vic, I can't reproduce your problem either. Given that 4 of us with different PC's and versions of Excel can't reproduce your problem it looks ...
Hi Astrit, Just do as already suggested here 1. Allow users to load the same file from a shared network drive 2. Load an add-in from shared n...
Hi Vic, You can use something like YouTube, Vimeo or Daily Motion to host your video and then link to it here. Regards Phil
Hi Astrit A workbook that contains macros will not execute those macros if it is opened in Excel Online. The macros are still stored in the file...
Hi Hannes, There's no workbook attached. Regards Phil
Hi Themba as Velouria said, you haven’t explained what you are trying to do or why you are doing it. If we don’t understand the problem and the res...
Hi, We need to see the code to be able to help 🙂 Regards Phil
Hi, Can you please supply a workbook with sample data. Thx Phil
Hi Alison, You can use the Transpose function as explained here: Use OFFSET to get the range and then wrap it in TRANSPOSE. Regards Phil
I'll check this, thanks for letting me know.