Forum

Philip Treacy
Philip Treacy
@philipt
Admin
Member
Joined: Oct 5, 2010
Last seen: Jun 11, 2026
Topics: 61 / Replies: 1588
Reply
RE: Conditional formatting - After typing a new rule the result is not OK

Hi Jernej, Can you please supply the workbook so we can see what you have done. Regards Phil

7 years ago
Reply
RE: How to protect multiple sheet for different users

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....

7 years ago
Reply
RE: How to protect multiple sheet for different users

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 ...

7 years ago
Reply
RE: How To Manage Updates in your Shared VBA project

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...

7 years ago
Forum
Reply
RE: How to protect multiple sheet for different users

Hi Vic, You can use something like YouTube, Vimeo or Daily Motion to host your video and then link to it here. Regards Phil

7 years ago
Reply
RE: Share Macro Enabled File on OneDrive

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...

7 years ago
Forum
Reply
RE: Delete equal debits and credits

Hi Hannes, There's no workbook attached. Regards Phil

7 years ago
Forum
Topic
Forum
Replies: 3
Views: 3657
Reply
RE: VBA SCRIPT TO OFFSET SELECTED RANGE

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...

7 years ago
Forum
Topic
Replies: 2
Views: 1652
Reply
RE: calculating travel time from an address to surrounding suburbs

Hi, We need to see the code to be able to help 🙂 Regards Phil

7 years ago
Forum
Reply
RE: How to calculate based on details chosen from combobox?

Hi, Can you please supply a workbook with sample data. Thx Phil

7 years ago
Forum
Reply
RE: Change column to row with offset?

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

7 years ago
Forum
Reply
RE: Incorrect Video being referenced

I'll check this, thanks for letting me know.

7 years ago
Page 97 / 110
0