-
You have grouped the sheets in the workbook (To do this you either click on the first tab you want to group and holding down the shift key click on the last, or to select non-contiguous ones do the same with the control key). As you have seen this appends [Group] to the file name in the workbook title bar. To deselect the group sheets click on one that
-
Rick This is a guess, but I suspect that as you are already in the pivot table, as you are using the contextual menu, that it is not allowing a second connection for that table full stop. What I would do is set up a connection in a new tab and then go to the data menu, connections and look at the connection string. You should then go, in the same area
-
Jeff The only way I can replicate this every time is by entering the characters in auto correct. I would therefore still suspect that. It may be something malicious like a virus that is doing this? Apart from that, i'm stumped. The only reason I mention the language pack loaded was because, for example, i think Dutch uses ; instead of , not that
-
Jeff Interesting. I would look at thinks in this order Check Autocorrect in excel options under the office button and see if there is a ',' replaced with '%' entry Disable any add-ins that may be loading, again through excel options Make sure you have the correct language loaded under excel options. Passed that there may be something
-
Catherine [quote user="cferart"]This is proving a very popular Macro so I need to change it for individual preferences[/quote] You may want to think about how you do this within one macro though as you would not want to maintain ten different ones for different users though. If that is what you are looking for, then you might get into userforms
-
You would only be able to do this using RibbonX inside the file and in that regard you are better to add a new tab. This can be contained in the workbook and so would only be there when the workbook was opened. I use this all the time with tabs for departments, e.g a marketing tab for that team and a sales tab for that team. To look at it seems tricky
-
This UDF will return true if the cell provide for the parameter has a comment or false if not. You could put this in your workbook code modules or your personal.xls if you want it available to all open workbooks. It is volatile, so will re-calc when the workbook does, but if it is the only function and inserting a comment does not force a re-calc, you
-
Wendy Bob can either fetch it from there by clicking on your user name or you can attach it by clicking on the options tab when you are composing or replying to a post. For this occasion I'm sure Bob will fetch it to stop duplication but if you wanted to post it you could delete the one on your profile
-
This is highly theorectical as I am sure that the range each time in the source sheet will change, but let's presume it doesn't. The code should go in the workbook that contains the code you are copying (or your personal workbook), although the worksheet with the range to be copied MUST be active. It will then open the named workbook at the
-
It may be better to post the code you have now and we can add somthing to open and paste into another worksheet in another book. Irrespective, I would have a couple of questions Do you want the 'other' workbook to be dynamic or is it the same location and name each time or is it a new workbook? Ditto the worksheet Do you want to append the data