Hi Vic The codes to the file is not protected so you can see them if you press ALT-F11. I will recreate the file once more just in case your's i...
No problem.
Hi Dane Just in case the article by Jon Acampora is too overwhelming (since you are new to VBA/macros) you can give this a try Sub DelRows() Dim...
Hi Julie Thanks for your feedback. Glad it is working for you.
Hi Anders The strange thing is that Vic mentioned if logging in as admin there are no issues. There is nothing special about the VBA code other ...
Hi Vic I have added one line of code to the DisplaySheet module to enable the PivotTable. .EnablePivotTable = True You can add more if needed...
Hi Hasan To create the 3 colors, you will need to separate the hours into 3 different columns. You will need to sort your source data by hours. ...
Hi Vic I am still unable to replicate the problem using all the passwords. Which column are you trying to add? Which cell is giving you a proble...
Hi Julie Without knowing what your report structure looks like or what is between cells H11 and H23 etc. it is difficult to give you an accurate wo...
Hi Ali Please give more examples in an attached workbook. APPL and APPLS are not identical. You can try using a Pivot Table to do what you wa...
Hi Vic I don't have the problem described by you. I only noticed that the Use PivotTable Report is unchecked and this will prevent usage of the ...
Hi Melanie I saw a spelling error tmp_Frequency = Frenquencyarray(j) Should be Frequencyarray No idea if it is the cause. Sunny
Hi Vic What the file does is to unhide the sheet assigned to the user. The user can then work on that sheet. Only the admin can add more sheets ...
Hi Tolu Your codes looks incomplete. Both Milena's and my codes work on GIF as well. Make sure that the images are inside the range you speci...
Hi Melinda Based on the macro you provided, the MyTemp sheet will be deleted unless the macro encountered and error before that and fail to delete ...