386 reputation
11429
bio website jakesee.com
location Singapore, Singapore
age
visits member for 3 years, 6 months
seen 4 hours ago

Thinking


Mar
14
asked When does Excel decide to overflow text into adjacent cells, or cut them at the boundary?
Mar
9
comment “This file originated from an internet location” - How to mark this file as local and safe?
No. I don't want to mark the network location as safe. I want to mark the file as safe.
Mar
9
comment “This file originated from an internet location” - How to mark this file as local and safe?
No. I don't want to mark the network location as safe. I want to mark the file as safe.
Mar
8
comment “This file originated from an internet location” - How to mark this file as local and safe?
You were right... in that my file is in a network drive. Hence the warning. But still is there anyway to mark it as safe?
Mar
8
comment “This file originated from an internet location” - How to mark this file as local and safe?
Right click the file in Explorer? Then open up the regular Properties dialog that every file has? I don't see any unblock button. Only the Change Open With button and Advanced attributes button. I am using Windows 7.
Mar
8
asked “This file originated from an internet location” - How to mark this file as local and safe?
Mar
7
comment Copy Excel worksheet and maintain relative cell reference in formulas
A single routine is nice as I am manually CTRL+H now, but all these do not fix the refences for controls e.g. buttons, dropdowns and such; and named ranges.
Mar
7
comment Copy Excel worksheet and maintain relative cell reference in formulas
@WinOutreach4 if two or more sheets are edited by different people on different workbooks, we will want a merge eventually. That's when the problem comes in.
Mar
6
comment Create reusable custom shapes in Microsoft Excel or even Office in general
I didn't go to that extent. Just on a network location currently. But it might be more sleek to generate on-the-fly using VSTO excel add-in. Could include a preview pane etc.
Mar
6
comment Macros in Excel 2010 hangs
@Ahmad have you tried commenting out function calls and debug by elimination?
Mar
6
comment Copy Excel worksheet and maintain relative cell reference in formulas
the paste special values only paste the calculated values. I need the formulas to be copied over, WITHOUT WBA.xls appended.
Mar
6
comment Copy Excel worksheet and maintain relative cell reference in formulas
I already attempted to explain in my last paragraph, but i think it still wasn't clear. Yes, WBA and WBB are identical expect for one sheet in WBA. While designing that sheet in WBA, it is intended that all cell reference be relative to the sheet's workbook. The copy worksheet function appends all cell formulas with WBA, making it "absolute" and I do not want that.
Mar
6
asked Copy Excel worksheet and maintain relative cell reference in formulas
Mar
6
comment Create reusable custom shapes in Microsoft Excel or even Office in general
@datatoo and Raystafarian In case you are interested, please see my edit
Mar
6
revised Create reusable custom shapes in Microsoft Excel or even Office in general
added 183 characters in body
Mar
6
accepted Create reusable custom shapes in Microsoft Excel or even Office in general
Feb
18
comment Create reusable custom shapes in Microsoft Excel or even Office in general
That is such a dissapointment... thanks for the affirmative. I'm going to wait a few more days before marking as answer though. Hope there's tips and advice.
Feb
17
answered Freeware option for conducting surveys on the intranet
Feb
17
accepted Cannot access network server via hostname, can with IP
Feb
17
accepted Should attaching email to another email be a non-recommended practice?