ªð¦^¦Cªí ¤W¤@¥DÃD µo©«

[µo°Ý] ½Ð°Ý¦U¦ì¥ý¶i¡A¦p¦ó¥ÎVBA¼g¦bÀx¦s®æ¸Ì¸Ó­¶­¶½X?

¦^´_ 5# gn00713242
  1. 'ThisWorkbook ªºµ{¦¡½X
  2. Private Sub Workbook_BeforePrint(Cancel As Boolean) '¤u§@ªí¦³¦L¦C®ÉªºÄ²°Êµ{¦¡
  3.     Application.CalculateFull
  4.     'CalculateFull ¤èªk ±j­¢¹ï©Ò¦³¶}±Ò¬¡­¶Ã¯¤¤ªº¸ê®Æ¶i¦æ§¹¾ã­pºâ
  5. End Sub
½Æ»s¥N½X
·P®¦ªº¤ß......(¦b³Â»¶®a±Ú°Q½×°Ï.¥Î¤ß¾Ç²ß·|¦³¶i¨Bªº)
¦ý¸ê·½µL­­,«á´©¦³­­,  ¤@¤Ñ1¤¸ªºÃÙ§U,¤H¤H¦³¯à¤O.

TOP

        ÀR«ä¦Û¦b : ¦³®É·í«äµL®É­W¡A¦n¤Ñ­n¿n«B¨Ó³¡C
ªð¦^¦Cªí ¤W¤@¥DÃD