Forum

Philip Treacy
Philip Treacy
@philipt
Admin
Member
Joined: Oct 5, 2010
Last seen: Sep 16, 2025
Topics: 61 / Replies: 1581
Reply
RE: Pyramidion Cryptocurrency needs an API URL for reporting our price to exchanges from an Excel sheet's single cell.

Hi Damon, As Pyramidion isn't yet supported on CoinGecko this task can't be done. You could write some code to connect to the CoinGecko API and ...

7 years ago
Reply
RE: How do I program a stop and then resume with a macro?

Hi Aaron, There are a number of ways to make your code pause, check this Does this process have to be written in VBA? Could you use Python? ...

7 years ago
Forum
Reply
RE: If... then copy a cell

Hi Janine, You can learn to use the IF function with these posts In E2 you need =IF(B2=0,A2,"") and in G2 =IF(B2=0,$B$1,"") ...

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

Hi Vic, I don't have any issues adding data to that workbook or adding/deleting columns. The issue seems to be specific to whatever setup you ha...

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

Hi Vic, The VBA module in your workbook is password protected so I can't look at it. I never run VBA without checking it over first. Phil

7 years ago
Reply
RE: How to automatically generate invoices for selected rows

Hi, Can you please attach your workbook so we can see what you are working with. Regards Phil

7 years ago
Forum
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
Page 96 / 110