This topic has been archived. It cannot be replied.
-
工作学习 / 学科技术讨论 / 向高手请教EXCEL VB问题头给了一个EXCEL表, 打开一看, 里面有调用别的SHEET的数据. 用Project explore 看到有几个SHEET, 但我却看不到里面的内容, 没办法UPDATE, 那位指点一下, 如何搞定...多谢.
-largesuv(黑熊走进玉米地);
2008-8-15
{159}
(#4621477@0)
-
是不是隐藏了？
-maple2047(枫树湾);
2008-8-15
(#4621550@0)
-
如果是调用其他workbook的内用，那么被调用的workbook也要打开
-sesk(sesk);
2008-8-16
(#4622149@0)
-
Not sure it’s about VBA or just about cell reference to other sheet.
-deep_blue(BLUE);
2008-8-16
{516}
(#4622723@0)
-
我用VB EDITOR, 在MS EXCEL OBJECT下看到被调用的OBJEC "SHEET2(CELL SITE), 但用VIEW OBJEC去看是, 菜单是灰的, 看不了.
-largesuv(黑熊走进玉米地);
2008-8-16
(#4622753@0)
-
Double click Sheet2. But I guess it’s empty. Many Excel features do not need code to achieve at all.If the content of Sheet2 is not visible, you can view it by
Format -> Sheet -> Unhide...
In Unhide window, select CELL SITE and click OK.
-deep_blue(BLUE);
2008-8-18
{172}
(#4624828@0)
-
多谢大侠指点, 终于看到它了...
-largesuv(黑熊走进玉米地);
2008-8-18
(#4625465@0)
-
format > sheet > unhide.
-jeffrey815(Smartiecat);
2008-8-16
(#4622726@0)