Sparklines excel 2016 for mac3/16/2023 ![]() I have checked VBA and can confirm that the macro is a module within the file I am using and NOT the old version just mentioned, however for some reason the old file opens up all the time.Ĭan anyone advise as to why this is opening up an old spreadsheet and devise a correction to fix this issue? I am concerned that if the old version ever gets deleted (or path changed) then the code will no longer work. However everytime I run the macro above it seems to open up an old version of the file (the same version where the macro was written). Wb.Sheets(ShtNames(i)).Visible = Not wb.Sheets(ShtNames(i)).Visible ShtNames = Array("Safety_Incident Report", "Action Report", "ASI Report") In the Insert Sparklines dialog box, notice that the first box is already filled based on your selection in step 1. ![]() On the Charts tab, under Insert Sparklines, click the kind of sparkline that you want. I have the following Macro for doing this: Select the data range for the sparklines. I have a spreadsheet which I want to toggle sheet visibility. ![]() Firstly, apologies for the post above, my first time posting.
0 Comments
Leave a Reply.AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |